# -*- coding: utf-8 -*-

import json
import pandas as pd

data = []
json_array = []
with open('C:\\Users\\zhufeifei\\Desktop\\111.txt', 'r', encoding='UTF-8') as fr:
    for line in fr:
        json_array.append(line)

json_str = ''.join(json_array)
json_array = json.loads(json_str, encoding='utf-8')
if isinstance(json_array, list):
    df = pd.DataFrame()
    for item in json_array:
        # TODO 有问题
        df.append(pd.DataFrame(item), ignore_index=True)
    print(len(df.columns))
    df.to_excel('C:\\Users\\zhufeifei\\Desktop\\111.xlsx', startcol=0, index=False)